home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Hand Picked Software
/
Hand Picked Software.iso
/
applicat
/
aseasy
/
samples.doc
< prev
next >
Wrap
Text File
|
1995-03-13
|
12KB
|
197 lines
╔═════════════════════════════════════════╗
║ Sample AS-EASY-AS Templates ║
║ --------------------------- ║
║ (C) Copyright 1992, TRIUS, Inc. ║
╚═════════════════════════════════════════╝
The AS-EASY-AS template worksheets described here, INSURE.WKS
and LEASE.WKS, are provided as samples of the power of this
unique program.
DISCLAIMER
~~~~~~~~~~
THESE PROGRAMS ARE PROVIDED ON AN "AS IS" BASIS WITHOUT WARRANTY OF
ANY KIND, EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE
IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
PURPOSE. THE ENTIRE RISK AS TO QUALITY AND PERFORMANCE OF THESE
PROGRAMS IS WITH YOU. SHOULD THE PROGRAM PROVE DEFECTIVE, YOU (NOT
TRIUS, INC.) ASSUME THE ENTIRE COST OF ALL NECESSARY REPAIR,
SERVICING, OR CORRECTION. IN NO EVENT WILL TRIUS, INC. BE LIABLE
TO YOU FOR ANY DAMAGES, INCLUDING ANY LOST PROFITS, LOST SAVINGS,
OR OTHER INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE
OR INABILITY TO USE THESE PROGRAMS, EVEN IF TRIUS, INC. HAS BEEN
ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
INSURE.WKS AS-EASY-AS TEMPLATE
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This is a typical situation that most of us have encountered at one
time or another. While looking around for life insurance, you find
out that you can get $50,000 of term life insurance for a monthly
premium of $9.50. When you are ready to buy that policy, you
realize that although this is a relatively low rate, a term policy
usually does not build any cash value. An insurance representative
offers to sell you a whole life policy which will have a cash value
of $10,000 after 25 years, with a monthly premium of only $23.
A simple way to try and figure out which is a better offer, would be
to look at the difference of the two premiums,
$23.00 - $9.50 = $13.50 per month, or
$162.00 per year, or
$4050.00 over 25 years.
On the surface, then, it looks that over a 25 year period, the whole
life policy would cost you $4050.00 more but would have a $10,000.00
cash value, so you are making out quite well.
This, however, is only half the story. Since the term insurance
would cost you $13.50 less a month, you could deposit that extra
money in the bank, thus collecting interest over the 25 years of the
policy.
The INSURE worksheet gives you the ability to perform all such
calculations automatically, and therefore, make a much more informed
choice about which type of insurance policy to purchase.
The screen of the example, discussed above, is provided
below. Note that the negative value in the "Savings/Losses" column
indicates that the term insurance policy would result in losing
$644.58, therefore the whole life option, under these circumstances,
is preferable.
EXAMPLE INSURE.WKS Screen
-------------------------------------------------------------
Compare Cost of Whole Life and Term Insurance
-------------------------------------------------------------
Alt-I to Enter Data, Alt-P to Print
-------------------------------------------------------------
Annual Premium for Term Insurance $114.00
Annual Premium for Whole Life Insurance $276.00
Whole Life Cash Value Period (years) 25.00
Whole Life Cash Value at end of Period $10,000.00
Average Annual Interest Rate over Period 6 %
Future Value of Difference in Premiums $9,355.42
Savings (+) Losses (-) with Term -$644.58
-------------------------------------------------------------
NOTE: The solution contained in INSURE.WKS assumes that the term
insurance and the whole life insurance premiums remain the same and
that you faithfully deposit the premium difference in a savings
account every month.
LEASE.WKS AS-EASY-AS TEMPLATE
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
As the tax laws are always changing, and interest (other than for a
home mortgage) is no longer deductible, more and more of us are
becoming interested in leasing our automobiles. Deciding whether
to do it or not, however, is not the easiest thing in the world.
There are many factors one has to consider before deciding to buy or
to lease.
The accompanying worksheet template, LEASE.WKS, will make the job
somewhat easier for you.
As the opening screen indicates, pressing Alt-I invokes the data
input routine. Motion is restricted to the cells containing values
that may be modified (highlighted or green on a color monitor).
As you are altering the input values, the template automatically
calculates the savings (or loss) of leasing versus purchasing the
automobile.
You should keep in mind that this is only a tool to help you decide,
the final decision is YOURS to make. The template attempts to
account for most factors that would enter a purchase/lease
calculation and the correctness of the result strongly depends on
the accuracy of the input data.
The table below contains an example of a purchase/lease
comparison. As you can see, the last entry in the table "Lease (+)
Purchase (-) Savings" contains a positive value. This indicates
that under the conditions described by the data entered by the user,
leasing the automobile would result in savings of $763.59.
Lease OR Purchase Automobile
Press Alt-I to Enter Data, Alt-P to Print
+-----------------------------------------------------------+
| Number of years (Lease and Loan) 3 |
| Interest Rate for Loan (per year) 14.00 % |
| Sale Price of Automobile $22,000.00 |
| Purchase down payment $16,000.00 |
| Amount financed (loan) $6,000.00 |
| Loan Monthly Payment $205.07 |
| Average Monthly Maintenance cost $30.00 |
| Total monthly Cost $235.07 |
| Monthly Lease payment $415.00 |
| Resale value at end of Lease/Loan $14,000.00 |
| Interest Rate on savings (per year) 8.00 % |
| Present Value Cost of Loan $7,501.37 |
| Present Value of Resale Price $11,021.56 |
| Present Value cost of purchase $12,479.81 |
| Present Value of Lease Payments $13,243.40 |
| Lease (+) Purchase (-) savings $763.59 |
+-----------------------------------------------------------+
SOLVE.WKS AS-EASY-AS TEMPLATE
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This is a simple template that given values for three unknowns, in an
equation, will solve for the fourth.
When the file is first retrieved, you will notice that the column
labeled "Input" is the only one containing values. That is the only
column where input is permitted.
The column to the right contains the solution for the unknown with no
input value. A message appears at the bottom of the table indicating
that at least ONE of the variables (to solve for) should have no input.
Place the cursor on one of the input cells and use the /Range, Erase
command to see the template produce the desired results.
TILE.WKS AS-EASY-AS TEMPLATE
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
A simple template that demonstrates the program's ability to
display multimple views of your worksheet and display text and
graphics at the same time (if your hardware supports it).
Simple instructions are provided on screen.
GRAPHS.WKS AS-EASY-AS TEMPLATE
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
A template with simple examples of the fourteen types of
graphs available in AS-EASY-AS Ver. 5.5. It also demonstrates
the macro language capabilities of the program, with user defined
menus, etc.
Simple instructions are provided on screen.
BOX.WKS AS-EASY-AS TEMPLATE
~~~~~~~~~~~~~~~~~~~~~~~~~~~
A macro driven template that demonstrates the Box formatting
capabilities of the program. Self-explanatory!
--------------------------------------------------------------- *END